create table if not exists d_enp_ppm_ismg_htyw_detail_h_#{PARTITION_DATE}
 (
ismpg01    datetime ,
ismpg02    datetime ,
ismpg03    varchar(64) ,
ismpg04    bigint ,
ismpg05    bigint ,
ismpg06    double ,
ismpg07    bigint ,
ismpg08    bigint ,
ismpg09    bigint ,
ismpg10    bigint ,
ismpg11    bigint ,
ismpg12    double ,
ismpg13    double ,
ismpg14    double ,
ismpg15    bigint ,
ismpg16    double ,
ismpg17    double ,
ismpg18    double ,
ismpg19    bigint ,
ismpg20    bigint ,
ismpg21    bigint ,
ismpg22    bigint ,
ismpg23    double ,
ismpg24    bigint ,
ismpg25    bigint ,
ismpg26    double ,
ismpg27    bigint ,
ismpg28    bigint ,
ismpg29    bigint ,
ismpg30    double ,
ismpg31    bigint ,
ismpg32    bigint ,
ismpg33    double ,
objectid    varchar(128) ,
objectname    varchar(64)
)   compress(5, 5)  nolock ;